﻿CREATE ROLE [MemberServer]
GO

GRANT SELECT, INSERT, UPDATE, DELETE ON [dbo].[tblStg_DbTblInd_Names] TO [MemberServer]
GO
GRANT SELECT, INSERT, UPDATE, DELETE ON [dbo].[tblStg_IndexUsage] TO [MemberServer]
GO
GRANT SELECT ON [dbo].[tblWH_Config] TO [MemberServer]
GO
GRANT SELECT, INSERT, UPDATE, DELETE ON [dbo].[tblWH_DbTblInd_Names] TO [MemberServer]
GO
GRANT SELECT, INSERT, UPDATE, DELETE ON [dbo].[tblWH_IndexUsage] TO [MemberServer]
GO
GRANT SELECT, INSERT, UPDATE, DELETE ON [dbo].[tblWH_Log] TO [MemberServer]
GO
GRANT SELECT, INSERT, UPDATE, DELETE ON [dbo].[tblWH_Perfmon] TO [MemberServer]
GO
GRANT SELECT, INSERT, UPDATE, DELETE ON [dbo].[tblWH_PerfmonHourlySummary] TO [MemberServer]
GO
GRANT SELECT, INSERT, UPDATE, DELETE ON [dbo].[tblStg_ServerRoleMembers] TO [MemberServer]
GO
GRANT SELECT, INSERT, UPDATE, DELETE ON [dbo].[tblStg_Alerts] TO [MemberServer]
GO
GRANT SELECT ON [dbo].[tblMSX_server_discovery] TO [MemberServer]
GO
